-- -- create table space 
-- create tablespace testDB
-- datafile 'D:/app/Asministrator/orcl/testDB.dbf'
-- size 100m;

-- -- create coustomer
-- create user testdb indentified by Chen12345 default tablespace testDB;

-- grant connect to testdb;
-- grant resource to testdb;

-- connect testdb/testdb;

-- FROM TO DATE TIME 都是oracle关键字
create table train(
	id number(10) primary key,
	trainid varchar2(50) not null,
	frem varchar2(50) not null,
	te varchar2(50) not null,
	dato varchar2(50) not null,
	timo varchar2(50) not null,
	fares number(10) not null
);

create sequence train_id minvalue 0 increment by 1 start with 0;
-- 添加测试数据
insert into train(id,trainid,frem,te,dato,timo,fares)
values(train_id.nextval,"D312","上海","北京南","2018-08-17","19:10:00",780);

commit;
